Printing Inventory Reconciliation

1. Once you have entered all of the required information needed for the Inventory Reconciliation, command options will appear. Select Print (X).

2. The following message will appear: "Print Detail? No/Yes."

• Select no if you do not want transaction detail included.
• Select yes to include transaction detail.

3. Command options will appear allowing you to print or choose from a set of other print options.

The report will print the following based on the filter selected – off-by, not taken, or all items.

• Dpt – The department ID
• Item Description – The item name
• UN – The stocking unit of measure
• On-hand – The current on-hand balance
• Physical – The physical count balance entered
• Off-By amounts – The variance between the on-hand and the physical count balance entered.

The detailed report will print the following based on the filter selected – off-by, not taken, or all items.

• MG GR – The item class for the item
• Itm Grp – The item group
• Item name – The item name
• Vendor/Cust – The vendor ID and name for the purchase order, the customer ID and name for sales orders
• Ref # – The reference number of the transaction
• Vend/Inv/Cust PO – The vendor invoice number, if applicable, for the purchase order, the customer purchase order number for the sales order
• Cost/Price – The purchase cost on the purchase order, the selling price for the sales order
• UN – The unit of measure for the transaction
• Quantity – The quantity on the transaction
• Date – The date of the transaction
• On-Hand – The current on-hand balance
• Off-By – The current off-by or variance between the current on-hand balance and the current physical balance
• Date - Inv – The inventory balance calculated by the system by taking the current on-hand balance plus or minus the transaction detail if the last physical plus one day or the last physical inventory balance if the last physical inventory balance if there were no transactions between the last physical inventory and the system date.

For more information on the Inventory Reconciliation option see Inventory Reconciliation.

Security Required : Inventory - Inventory Reconciliation